1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Drawing;
5 using System.Data;
6 using System.Linq;
7 using System.Text;
8 using System.Threading.Tasks;
9 using System.Windows.Forms;
10 using System.Data.SqlClient;
11
12 namespace SoftQuanLyNhaHang.Models
13 {
14 class BaoCaoMod
15 {
16 protected DateTime NgayHomNay { get; set; }
17 protected string TrangThaiGiaoDich { get; set; }
18 protected string TrangThaiNhapHang { get; set; }
19
20 protected DateTime KyNay { get; set; }
21
22 protected DateTime TuNgay { get; set; }
23 protected DateTime DenNgay { get; set; }
24
25 public BaoCaoMod()
26 { }
27
28 public BaoCaoMod(DateTime _KyNay)
29 {
30 KyNay = _KyNay;
31 }
32
33 public BaoCaoMod(DateTime _TuNgay, DateTime _DenNgay)
34 {
35 TuNgay = _TuNgay;
36 DenNgay = _DenNgay;
37 }
38
39 public BaoCaoMod(DateTime _NgayHomNay, string _TrangThaiGiaoDich, string _TrangThaiNhapHang)
40 {
41 NgayHomNay = _NgayHomNay;
42 TrangThaiGiaoDich = _TrangThaiGiaoDich;
43 TrangThaiNhapHang = _TrangThaiNhapHang;
44 }
45
46
47 //khach hang truoc
48 public DataSet uctBaoCao_Gets_KetThucNgayLamViec()
49 {
50
51 DataSet ds = new DataSet();
52 string[] paras = new string[3] { "@NgayHomNay", "@TrangThaiGiaoDich", "@TrangThaiNhapHang"};
53 object[] values = new object[3] { NgayHomNay, TrangThaiGiaoDich, TrangThaiNhapHang };
54 ds = Models.connection.FillDataSet("uctBaoCao_Gets_KetThucNgayLamViec", CommandType.StoredProcedure, paras, values);
55 return ds;
56 }
57
58 //hien thi danh sach thu chi ky nay, ky truoc, ky sau
59 public DataSet uct_BaoCao_HienThi_ThuChi()
60 {
61 DataSet ds = new DataSet();
62 string[] paras = new string[1] { "@KyNay"};
63 object[] values = new object[1] { KyNay};
64 ds = Models.connection.FillDataSet("uct_BaoCao_HienThi_ThuChi", CommandType.StoredProcedure, paras, values);
65 return ds;
66 }
67 //bao cao ton kho
68 public DataSet uct_BaoCao_HienThi_TonKho()
69 {
70 DataSet ds = new DataSet();
71 string[] paras = new string[2] { "@TuNgay","@DenNgay" };
72 object[] values = new object[2] { TuNgay, DenNgay };
73 ds = Models.connection.FillDataSet("uct_BaoCao_HienThi_BCTonKho", CommandType.StoredProcedure, paras, values);
74 return ds;
75 }
76
77 public DataSet uct_BaoCao_HienThi_ThuChi_TuNgay_DenNgay()
78 {
79 DataSet ds = new DataSet();
80 string[] paras = new string[2] { "@TuNgay", "@DenNgay" };
81 object[] values = new object[2] { TuNgay, DenNgay };
82 ds = Models.connection.FillDataSet("uct_BaoCao_HienThi_ThuChi_TuNgayDenNgay", CommandType.StoredProcedure, paras, values);
83 return ds;
84 }
85
86
87 }
88 }